DECLARE @TABLE TABLE
(
NAME VARCHAR(50),
NICKNAME VARCHAR(150),
EMAIL VARCHAR(150),
JOINDATE DATETIME
)

INSERT INTO @TABLE
(NAME, NICKNAME, EMAIL, JOINDATE)
values
('peter','fifaninja','peterphillip99@gmail.com','2012-03-07'),
('Charlie','BraVader','Charles@fifachamps.co.za','2012-03-07'),
('Khumo Moerane','Khumo187','khumo187@gmail.com','2012-03-07'),
('Faizel','The Champ','faizel.ismail@webafrica.com','2012-03-07'),
('wesley skeelaci','MFWIC','wesley2011@live.co.za','2012-03-07'),
('Clint','Zepher1979','ca.johannes@yahoo.com','2012-03-07'),
('Aphiwe Pasiya','Don','aphiwepasiya@yahoo.com','2012-03-07'),
('ziphozihle tshangana','zyra','ztshangana@gmail.com','2012-03-07'),
('David Wattoula','Skylop101','titeuf_10@yahoo.fr','2012-03-08'),
('Jerry Nkongolo','steve-level','jerrynkongolo@yahoo.fr','2012-03-08'),
('Keegan Lakay','2 Game Shake!!!','Keeganl09@live.co.za','2012-03-08'),
('Andre','Drester','andrethompson@live.co.za','2012-03-09'),
('Migheil','GameboyWP','migheil007@gmail.com','2012-03-09'),
('cedric','dims','dims_pain@hotmail.fr','2012-03-09'),
('Zahier Mohamed','Vuilbru Champ','zahier321@yahoo.com','2012-03-09'),
('Sizwe Cele','SVC','cele.sizwevela@gmail.com','2012-03-09'),
('Cheslin','cheslinho1977','cheslin.maduray@csgi.com','2012-03-09'),
('Zameer Parker','Gamer1','prkzam002@gmail.com','2012-03-09'),
('chad cuddumbey','the General','game-bws@live.co.za','2012-03-09'),
('Shane Cuddumbey','Lsd-j','sc.sfe1@hotmail.com','2012-03-09'),
('joel joseph','JJ jackson','jd.joseph22@gmail.com','2012-03-09'),
('Maxwell Lawrence','Max Law','maxlaw@cellc.blackberry.com','2012-03-09'),
('kazadi','joey','jonathan_kazadi2001@yahoo.fr','2012-03-09'),
('buyile','Proff','matiwanebuyile@yahoo.com','2012-03-10'),
('Benjamin','Thierry','ntsika11@gmail.com','2012-03-10'),
('Ayanda','Bhuda Ace','acegoba@yahoo.com','2012-03-10'),
('Laudel ','Larrydav','laudelamani@yahoo.fr','2012-03-10'),
('joe','berthy ','Joeberthy@hotmail.com','2012-03-10'),
('Christian February','Jaykay','jaykay_ice@yahoo.com','2012-03-11'),
('Byron','Macwp1','byronm@gmail.com','2012-03-13'),
('Ricardo Rhode','Higgies','Rdtide9@gmail.com','2012-03-13'),
('akhona','akuna','tmatroko@gmail.com','2012-03-13'),
('Ricardo','Ricky','ricardobotha74@gmail.com','2012-03-15'),
('Justin','Johnny','ricardobotha74@gmail.com','2012-03-15'),
('Tiro','Tiro','tyro.flyfella@gmail.com','2012-03-16'),
('tauriq','he is robin','t.sky343@gmail.com','2012-03-16'),
('Fabrice Muya','Sovereign Ent.','fabricce.muya@live.com','2012-03-18'),
('Fabrice Muya L','Sovereign Ent.','fabrice.muya@live.com','2012-03-18'),
('Julio America','The Enigmatic Extremist','julio2up@gmail.com','2012-03-18'),
('PHUMLANI','PHISTOZZ','pmkhulungu@webmail.co.za','2012-03-18'),
('rohney','EL Pipita','rohneyp@yahoo.com','2012-03-19'),
('GORDON','MR KEER','lokailweog@yahoo.com','2012-03-19'),
('Vuyani','Mavij','209095318@cput.ac.za','2012-03-20'),
('Amien Moos','Psycosis','damien169@gmail.com','2012-03-20'),
('Imran Gafieldien','mavric69','igafieldien@shoprite.co.za','2012-03-20'),
('kudzai','kc','chrisgwinji@yahoo.com','2012-03-20'),
('Motlalepula ','tlali','211160830@cput.ac.za','2012-03-20'),
('ernie leo','eltee','ernieleo2000@yahoo.com','2012-03-20'),
('ernest kuubagr','eltee','ernieleo2000@yahoo.com','2012-03-20'),
('NITHAR MATTHEWS','NATE','NITHAR@MTN.BLACKBERRY.COM','2012-03-20'),
('SABRI ABRAHAMS','SABS','SABRI.ABRAHAMS@GMAIL.COM','2012-03-20'),
('Ghaled Ariefdien','George55','ghaleq@googlemail.com','2012-03-20'),
('barry','boere','sir.boere@gmail.com','2012-03-20'),
('saadiq','saadiq','hoosainsaadiq786@gmail.com','2012-03-20'),
('Anton','Gun slinger','anton.elliott@gmail.com','2012-03-22'),
('Ethienne','Killer Breeze','ethienneappels1@gmail.com','2012-03-22'),
('siphamandla','sups','siphamandlasp@gmail.com','2012-03-22'),
('Thabo','Thibos','tpmbenenge@gmail.com','2012-03-22'),
('Ghaazim Allie','Zeebs','ghaazim.ace@gmail.com','2012-03-22'),
('hhhhhhhhhhhhhhhhhhhhDerron Crouch','Derron202','DCrouch2@oldmutual.com','2012-03-22'),
('Thembile','Le Chero','teefaster@gmail.com','2012-03-22'),
('Nadiem Carlse','Nadis','nadeem.carlse@gmail.com','2012-03-23'),
('Jonathan Gaika','PapaAction','jonathangaika@yahoo.com','2012-03-23'),
('kwazi','sean76','dyosikwazi@yahoo.com','2012-03-23'),
('Karabo Molema','Karabo','komolema@gmail.com','2012-03-23'),
('dumezweni','barca','212210599@mycput.ac.za','2012-03-23'),
('siphosethu','mphora','siphosethu.kaleni@gmail.com','2012-03-23'),
('Olwethu','Olwethu','amadlozi@webmail.co.za','2012-03-23'),
('Siyanda','Mr Bitches','siya.nick@gmail.com','2012-03-26'),
('Moses','Mo','ikanengm@gmail.com','2012-03-26'),
('Jason Marais','Jayo26','jasonm26@gmail.com','2012-03-27'),
('Si Elrick','SimpleSimon or SimonSez','pushbutin@gmail.com','2012-03-27'),
('Abubakr Lillah','Abubakr','abubakrl25@gmail.com','2012-03-27'),
('ABDUL-RAZAQ','STITCH','RAZAQ087@GMAIL.COM','2012-03-27'),
('Yazeed','Zeedy','ykarriem880@gmail.com','2012-03-27'),
('Zeeshaan Salie','Zeebo','zeeshaansalie@gmail.com','2012-03-27'),
('Yazeed karriem','okapipe','ykarriem880@gmail.com','2012-03-27'),
('Randall De Grill','Randz','rdegrill@gmail.com','2012-03-27'),
('Achmad','Akes','Ybooley@mf.co.za','2012-03-27'),
('SANELE','SANELEZ','sanele-z@webmail.co.za','2012-03-28'),
('Andre Costa','Ze Da Crista','viciado_100@hotmail.com','2012-03-29'),
('Miller Quinta','Jamie','millerquinta30@hotmail.com','2012-03-29'),
('eduardo','cokytoh','eduardocoky@hotmail.com','2012-03-29'),
('Eduardo Coelho','cokytoh','eduardocoky@hotmail.com','2012-03-29'),
('ZAMA','ZEETO','zamntuli@gmail.com','2012-03-30'),
('Katlego Kurata','Kaddy','kadi_lac@live.com','2012-03-31'),
('mzingisi ','Mzee ','molefe91@mobileemail.vodafinesa.co.za ','2012-03-31'),
('Siviwe Valtyn','MusicHead','musicheadbeatz@gmail.com','2012-04-01'),
('Mubeen','MOBi','mubeengaffoor@yahoo.co.uk','2012-04-01'),
('Heinz','Heinz','heinzhey@gmail.com','2012-04-01'),
('Talieb Mohamed','taliebm','taliebm@gmail.com','2012-04-01'),
('Danai Guruva','danaiGuru','gndguruva@yahoo.com','2012-04-02'),
('Muneeb Adams','M21','m21n5e2@gmail.com','2012-04-02'),
('Hilton Serere','Hilton','shserere@gmail.com','2012-04-02'),
('zubair','zubs','bawa328@gmail.com','2012-04-03'),
('reza','afridi','rzll_hoosain@yahoo.com','2012-04-03'),
('Bradley Steenberg','Brad','bsteenberg1@gmail.com','2012-04-03'),
('Byron Mac Donald','Macwp1','byron.macd14@gmail.com','2012-04-03'),
('Rosco','Terry','terrygolf@mweb.co.za','2012-04-03'),
('idrees','idie','idrees.charles@gmail.com','2012-04-04'),
('Clayton Fredericks','Stunner','cfclayton7@gmail.com','2012-04-04'),
('Faizel Gomez',' Faizie','jonathangaika@gmail.com','2012-04-04'),
('Ashraf Stakala','Ash','ashrafstakala@gmail.com','2012-04-04'),
('Asanda','brown','asndavumazonke@yahoo.com','2012-04-04'),
('Abu','Mikk','abu@maingaming.co.za','2012-04-04'),
('Safwaan','Saffie','safwaan@webafrica.co.za','2012-04-05'),
('Dumisani','Dim','dimlambo@gmail.com','2012-04-05'),
('Abubakr','Abubakr','alillah@ipmglobal.org.za','2012-04-05'),
('Karabo Mokae','Karabz','karabo@wmmmedia.co.za','2012-04-05'),
('Mncedisi Mbopa','Disi(DC)','m_mbopa@yahoo.com','2012-04-05'),
('Ron','the sich','shizz_12@hotmail.com','2012-04-05'),
('Frikkie','Gevalik','fgburger@gmail.com','2012-04-06'),
('Thabang Wessie','Basco','thabangwessie@gmail.com','2012-04-06'),
('thabang wessie1','Thabang','thabangwessie@gmail.com','2012-04-06'),
('Imraan Ehrenreich','Imza','imraanehrenreich@yahoo.com','2012-04-06'),
('Uzair','Uzzi','www.uzzimanutd@gmail.com','2012-04-06'),
('Brent Richard Meyer','Nega-Ninja','210071494@mycput.ac.za','2012-04-10'),
('Mac Sacco','Frank','macfuct@yahoo.com','2012-04-12'),
('Rohan de Jongh','Roebou1989','rohandejongh@yahoo.com','2012-04-12'),
('Dirk Kroon','Dirka1992','kroon158@gmail.com','2012-04-14'),
('Francois van Schlakwyk','fraansman','fraansman88@webmail.co.za','2012-04-25'),
('odwa','o.d','sthamatroko@gmail.com','2012-04-26'),
('Yazeed Zeedy Karriem','oka pipe','ykarriem880@gmail.com','2012-05-03'),
('Musawenkosi','Mus-Man','nmusa@rocketmail.com','2012-05-03'),
('Andrew-lee','Franchizeboy87','atobias@coronation.co.za','2012-05-04'),
('Karabo Dlodlo','colonel','karabodlodlo@rocketmail.com','2012-05-04'),
('Philipp Kruse','phil','philipp-kruse@web.de','2012-05-04'),
('Vincent','Vhsk','Vincentjoest@web.de','2012-05-04'),
('Mark van de Bovenkamp','Markus','mark88@live.nl','2012-05-04'),
('Muhammad Suleman','MOE','moe_suleman@yahoo.com','2012-05-05'),
('Sbu','Sub-Real','wsmasuku@gmail.com','2012-05-05'),
('razaq','stitch','razaq087@gmail.com','2012-05-07'),
('Shameegh','Sham','shameeghboer@gmail.com','2012-05-07'),
('ABDUL','STITCH','RAZAQ087@GMAIL.COM','2012-05-11'),
('Zameer','prkzam002','prkzam002@gmail.com','2012-05-21'),
('yazeed1','okapipe','ykarriem880@gmail.com','2012-05-25'),
('abdul-razaq786','stitch','razaq087@gmail.com','2012-05-25'),
('tapiwa','firstaid','manyenga@gmail.com','2012-05-25'),
('Andrew','Worlz','aworling@gmail.com','2012-05-26'),
('Darren','d3dm1c','mic2425@gmail.com','2012-05-26'),
('Warren','Walcott','Warrenjansen1993@gmail.com','2012-05-27'),
('Keegan Mossick','Keegs ','kmossick@gmail.com','2012-05-27'),
('Riaan Theunissen','Riatrix','riatrix123@gmail.com','2012-05-27'),
('Brian Arendse','Magpie','Brian.arendse@mf.co.za','2012-05-27'),
('Kabelo','Kboss','kabelo.mokoka@aurecongroup.com','2012-05-29'),
('Adiel Kamalie','Kanji25','Adiel07@vodamail.co.za','2012-05-29'),
('Darion','Deez','darionclark@gmail.com','2012-05-29'),
('Waseem Garder','wasmo','wasgar04@gmail.com','2012-05-29'),
('riaan ','riatrix ','riatrix123@gmail.com ','2012-05-29'),
('Kurt Baker','weebo','baker.kurtmark@gmail.com','2012-05-30'),
('Zimele Vezi','Fysx','physixageia@gmail.com','2012-05-30'),
('Graham Boosyen','Graham','grahambooysen@yahoo.com','2012-05-31'),
('Dimitri','DD','dimitrid-p@hotmail.com','2012-06-01'),
('zuzu','zuzu','islandstyle84@gmail.com','2012-06-02'),
('sean kaseke','KB','seankaseke@live.co.za','2012-06-02'),
('siya','the legend','mithajayiya@gmail.com','2012-06-03'),
('deen auld','bucho','deenauld@yahoo.com','2012-06-03'),
('Adam Hendricks','Adam','ahtalriq0@gmail.com','2012-06-03'),
('Jonathan Van Zyl','Jono VZ','jonathanisavanzyl@yahoo.com','2012-06-04'),
('Matthew','MVP','cloetematthew@gmail.com','2012-06-04'),
('Matthew_C','MVP','cloetematthew@gmail.com','2012-06-04'),
('Devin','Devin','devin.devries@gmail.com','2012-06-04'),
('Dylan ','Eish','dylanbrent@gmail.com','2012-06-04'),
('Nic Carr','mobyfish','mobyfish@gmail.com','2012-06-04'),
('Jodi Dennis','Jowa','16171950@sun.ac.za','2012-06-04'),
('jody','cody b','jodyvanniekerk25@gmail.com','2012-06-04'),
('Rohan','Roebou1989','rohandejongh@yahoo.com','2012-06-04'),
('Bradley Philander','Baatie','BradleyPhilander@Yahoo.com','2012-06-05'),
('Cale Pissarra','Football101','calepissarra@gmail.com','2012-06-05'),
('Kris van Zyl','k-1','pendulum1@hotmail.com','2012-06-05'),
('lupe','lamigo','3076831@uwc.ac.za','2012-06-06'),
('cameron watson','none','cam.watson@aol.com','2012-06-06'),
('brett','TheGunneR','batweasel333@hotmail.com','2012-06-06'),
('Zaid Solomon','Zaid','zaisolhome01@ravemail.co.za','2012-06-06'),
('Peter-John Offner','PJ Carragher','greenresidue@gmail.com','2012-06-06'),
('Henty','henty','15996999@sun.ac.za','2012-06-06'),
('Andrew Tobias','Franchizeboy87','atobias@coronation.co.za','2012-06-07'),
('hanselouw','tollie','hanselowm@savino.co.za','2012-06-07'),
('Llewelyn','Lew','Llewelyn21@hotmail.com','2012-06-07'),
('Kyle Van Eck','Blaq','kylevaneck@yahoo.com','2012-06-07'),
('Joe-Dean','Joe','streetrippr@yahoo.com','2012-06-07'),
('Myles','Mylo','myleskemp@hotmail.com','2012-06-08'),
('Christopher','Pear','christopherdaluz@yahoo.com','2012-06-08'),
('Stephan','Mack','stephan@hsm.co.za','2012-06-08'),
('yonga jacobs','yongz','yongajacobs@gmail.com','2012-06-08'),
('Steve','Soldier','nwosuchukafrancis@yahoo.com','2012-06-08'),
('xavier de vries','xavi','16210646@sun.ac.za','2012-06-08'),
('Yaseen','CrimsonFlame88','yaseenmanutd@gmail.com','2012-06-19'),
('RAZAQ786','STITCH','RAZAQ087@GMAIL.COM','2012-06-21'),
('YAZEED786','OKAPIPE','YKARRIEM880@GMAIL.COM','2012-06-21'),
('xliywc@vuabgv.com','xliywc@vuabgv.com','xliywc@vuabgv.com','2012-06-29'),
('tauhir','finisher','ta.uhir@hotmail.com','2012-07-01'),
('tauhir1','Ramo','ta.uhir@hotmail.com','2012-07-01'),
('neepie','neebo','omarmoeneeb@gmail.com','2012-07-01'),
('rhidaa','faker','orhidaa@ovi.com','2012-07-01'),
('IZAZ','IZAZ','RAZAQ087@GMAIL.COM','2012-07-04'),
('Linda Mali','Maroro','lindamali80@gmail.com','2012-07-06'),
('Monde Luphungela','Mundas','lindamali80@gmail.com','2012-07-06'),
('Pierre','Pie','Pierref.briers@gmail.com','2012-07-07'),
('Neville','Nev','nevkm@yahoo.fr','2012-07-12'),
('test','theplayer','peterphillip@cubetec.co.za','2012-07-30'),
('Mark Pote','Maak','marpot86@gmail.com','2012-07-30'),
('Tyrone Hunt','T-Bone','tyrone@atvantage.co.za','2012-08-08'),
('jealous muchero','jazz or jay','tindojeke@yahoo.co.za','2012-08-18'),
('Godfrey','Gotta','gdeybers@gmail.com','2012-08-22'),
('thierry','thierry henry','motomungu.thierry@gmail.com','2012-08-27'),
('Ebrahim o.','IcEmAnwp','ebrahim1981@gmail.com','2012-08-28'),
('Yazeedk','okapipe','Ykarriem880@gmail.com','2012-08-30'),
('Brendon','B','bkindo@gmail.com','2012-09-04'),
('ZAKIE','STITCH','RAZAQ087@GMAIL.COM','2012-09-05'),
('DUKE','DUKE','dukemzansi@gmail.com','2012-09-06'),
('Moegammad Nuhr','boere','ebrahim1981@gmail.com','2012-09-06'),
('Suleiman Salie','Laymie','laymie90@gmail.com','2012-09-06'),
('Zahier Salie','Pikkie','laymie90@gmail.com','2012-09-06'),
('Mahdee Ismail','theMardlez','mahdeeism@gmail.com','2012-09-09')



SELECT 
	NAME, NICKNAME, EMAIL, JOINDATE, 1
FROM 
	@TABLE
WHERE
	LOWER(EMAIL) NOT IN (SELECT LOWER(EMAIL) FROM FCT_Player)